SQL queries

This section is only valid for reports using ODBC data sources. Crystal Reports automatically generates an SQL query when you design a report based on one or more ODBC data source. This query is sent to the ODBC data source(s) as an instruction to gather the data needed by the report.

Note:    It is not recommended that you edit SQL queries in the manner described below unless you have experience with the SQL language. To create a customized query, see The Crystal SQL Designer.

To edit an SQL query

Tip:    Open a report based on an ODBC data source to follow this procedure.

  1. On the Database menu, click Show SQL Query.
    The Show SQL Query dialog box appears.

  2. Click anywhere inside the text area to begin making changes.
  3. Use the ANSI SQL language to fine-tune the SQL query.

    Note:    You cannot change the SELECT clause of the SQL statement.

    You can cut, copy, or paste any part of the query to or from the Clipboard if needed. For more information, see The SQL language.

  4. Click OK when finished.


Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com